<html>
 <head>
  <link href="./leetcode-problem.css" rel="stylesheet" type="text/css">
 </head>
 <body>
  <div class="question_difficulty">
   难度：Hard
  </div>
  <div>
   <h1 class="question_title">
    601. Human Traffic of Stadium
   </h1>
   <p>
    X city built a new stadium, each day many people visit it and the stats are saved as these columns:
    <b>
     id
    </b>
    ,
    <strong>
     visit_
    </strong>
    <b>
     date
    </b>
    ,
    <b>
     people
    </b>
   </p>
   <p>
    Please write a query to display the records which have 3 or more consecutive rows and the amount of people more than 100(inclusive).
   </p>
   For example, the table
   <code>
    stadium
   </code>
   :
   <pre>
+------+------------+-----------+
| id   | visit_date | people    |
+------+------------+-----------+
| 1    | 2017-01-01 | 10        |
| 2    | 2017-01-02 | 109       |
| 3    | 2017-01-03 | 150       |
| 4    | 2017-01-04 | 99        |
| 5    | 2017-01-05 | 145       |
| 6    | 2017-01-06 | 1455      |
| 7    | 2017-01-07 | 199       |
| 8    | 2017-01-08 | 188       |
+------+------------+-----------+
</pre>
   <p>
    For the sample data above, the output is:
   </p>
   <pre>
+------+------------+-----------+
| id   | visit_date | people    |
+------+------------+-----------+
| 5    | 2017-01-05 | 145       |
| 6    | 2017-01-06 | 1455      |
| 7    | 2017-01-07 | 199       |
| 8    | 2017-01-08 | 188       |
+------+------------+-----------+
</pre>
   <p>
    <b>
     Note:
    </b>
    <br>
    Each day only have one row record, and the dates are increasing with id increasing.
   </p>
  </div>
  <div>
   <h1 class="question_title">
    601. 体育馆的人流量
   </h1>
   <p>
    X 市建了一个新的体育馆，每日人流量信息被记录在这三列信息中：
    <strong>
     序号
    </strong>
    (id)、
    <strong>
     日期
    </strong>
    (date)、&nbsp;
    <strong>
     人流量
    </strong>
    (people)。
   </p>
   <p>
    请编写一个查询语句，找出高峰期时段，要求连续三天及以上，并且每天人流量均不少于100。
   </p>
   <p>
    例如，表
    <code>
     stadium
    </code>
    ：
   </p>
   <pre>+------+------------+-----------+
| id   | date       | people    |
+------+------------+-----------+
| 1    | 2017-01-01 | 10        |
| 2    | 2017-01-02 | 109       |
| 3    | 2017-01-03 | 150       |
| 4    | 2017-01-04 | 99        |
| 5    | 2017-01-05 | 145       |
| 6    | 2017-01-06 | 1455      |
| 7    | 2017-01-07 | 199       |
| 8    | 2017-01-08 | 188       |
+------+------------+-----------+
</pre>
   <p>
    对于上面的示例数据，输出为：
   </p>
   <pre>+------+------------+-----------+
| id   | date       | people    |
+------+------------+-----------+
| 5    | 2017-01-05 | 145       |
| 6    | 2017-01-06 | 1455      |
| 7    | 2017-01-07 | 199       |
| 8    | 2017-01-08 | 188       |
+------+------------+-----------+
</pre>
   <p>
    <strong>
     Note:
    </strong>
    <br>
    每天只有一行记录，日期随着 id 的增加而增加。
   </p>
  </div>
 </body>
</html>